pg_dump -Fc db_name > backup_file_with_date -U username -h endpoint.host.com

createdb db_name

pg_restore -d db_name backup_file_name_with_date